package com.ruoyi.app.controller.shop.mapper;

import com.ruoyi.common.core.dao.BaseMapper;
import com.ruoyi.common.entity.DO.shop.ShopAppletDO;
import org.apache.ibatis.annotations.Select;

public interface IShopAppletMapper extends BaseMapper<ShopAppletDO> {

    @Select("SELECT shop_id FROM shop_applet WHERE is_delete=0 and is_enable=1 and applet_app_id = #{appId}")
    Long getShopIdByAppId(String appId);

    @Select("SELECT review_status FROM shop_applet WHERE shop_id = #{shopId}")
    Integer getReviewStatusByShopId(Long shopId);
}
